UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XV/DkbuwPyXKWyzg8klSoKdy5b69dM0BOQjoSGFbtos='
WHERE
key_id = '9d916bbb50f3b1709a7c297952c2950aab53749f5cfb89498a969c220271bf34'
AND (
token = 'XV/DkbuwPyXKWyzg8klSoKdy5b69dM0BOQjoSGFbtos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)