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