UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8wA9CgCuPEwN0NMTHdT+x+fz902LVAHn3fF1Jt4QKE='
WHERE
key_id = '459bdc20123e7e014f2ae5349a819e227a10e64df0488f0caf3b58a72d99afdd'
AND (
token = 'T8wA9CgCuPEwN0NMTHdT+x+fz902LVAHn3fF1Jt4QKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)