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