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