UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'The0C/ek1RPi9TrdVWHntVTpxmy83Ut+3cXkG/Lm8oU='
WHERE
key_id = '04a9433c877300b30d9ce4102c80856ad8fba82ca9937877bbe272151cc8be19'
AND (
token = 'The0C/ek1RPi9TrdVWHntVTpxmy83Ut+3cXkG/Lm8oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)