UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AUx5JLRilbuPT+y0w43r71MSwXOg1Eeu7RbDY9EknmU='
WHERE
key_id = '5f862769051412a0fb2e163670f4dfe957f16cacc2964a095879613b646765ba'
AND (
token = 'AUx5JLRilbuPT+y0w43r71MSwXOg1Eeu7RbDY9EknmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)