UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CG9MVVucqMePLL6mnDEBuUt53UrEDotNGkN1oUfL2I0='
WHERE
key_id = 'b4bc0a967c3b942e437a721da76e45fd5ff91bc5b638088317b46d53e6f069f4'
AND (
token = 'CG9MVVucqMePLL6mnDEBuUt53UrEDotNGkN1oUfL2I0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)