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