UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NNe+I70jp76U42n0B0Aq4gfOnUjiut3mVnCiW/AXYo='
WHERE
key_id = 'ada36a182b31d08d68f3d9b0985f4cabc012b1fe45799dfdb2cfe7f227ca5c26'
AND (
token = '6NNe+I70jp76U42n0B0Aq4gfOnUjiut3mVnCiW/AXYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)