UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pTyXdIkENZBhKgqaW8p3bWrM+tE2dkS9prYR36+lnUY='
WHERE
key_id = 'be294a7d48df0d5425a49f597d09b1b4662109788f3514883d82483517b2b284'
AND (
token = 'pTyXdIkENZBhKgqaW8p3bWrM+tE2dkS9prYR36+lnUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)