UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TtwWP+C1Iz8sdRFBqnkJ5ODkfYJGLWTUrssDqyq3BFA='
WHERE
key_id = '165ebc14c750386eebc9dc9467832572e1ef6e9f47219cb31e8a1257f6cae622'
AND (
token = 'TtwWP+C1Iz8sdRFBqnkJ5ODkfYJGLWTUrssDqyq3BFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)