UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7mgxwDtPizpqPKInXEl7CYExS5BHZyVW3NhBG0Mt1lk='
WHERE
key_id = 'e84cc16ed5a66a2095b9b89b89743d03fa76c1dbc712bc70e29ddccf5d96b5c3'
AND (
token = '7mgxwDtPizpqPKInXEl7CYExS5BHZyVW3NhBG0Mt1lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)