UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TMnM3CDklPzIQif0iFMevUlmd/vg07ekYdl7YU+vqCU='
WHERE
key_id = '0cc444fb609188d6173fb447eabdcaa5e7a70d181dd4602be5e295ce443c0f33'
AND (
token = 'TMnM3CDklPzIQif0iFMevUlmd/vg07ekYdl7YU+vqCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)