UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lY6TfVKerozvV+BGNH84mrEOOMFdXwX0sS4pi/UUAvw='
WHERE
key_id = '1979dae7c2ec4152721f1dbb1ec18bbaa88740183f636f32e3c93d3bdcf8dc87'
AND (
token = 'lY6TfVKerozvV+BGNH84mrEOOMFdXwX0sS4pi/UUAvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)