UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXy6Mbncpx6AhKxyWZmIANrWIK4x6Xi/4HIoH0AojOM='
WHERE
key_id = 'a598d58c647613c2a0dd8dcc609ea6cdb7252bc2d5f033a272d603139ff68857'
AND (
token = 'TXy6Mbncpx6AhKxyWZmIANrWIK4x6Xi/4HIoH0AojOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)