UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/eF5tHtj3XYuHwnn8mwxS5MTck0QLc72ldVil1G2SVU='
WHERE
key_id = '0ef2ac9ac0b78bcd39297d089126821a93540421ee19718d8808f78de7c547ce'
AND (
token = '/eF5tHtj3XYuHwnn8mwxS5MTck0QLc72ldVil1G2SVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)