UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xhSmcGMI3qWCDm+1slD8JR66TeCRAFzZpZKZrkqPl+w='
WHERE
key_id = 'b471420c8ceb656f29b49354ac521f516215259614d4fcaad75be9af9e0240a9'
AND (
token = 'xhSmcGMI3qWCDm+1slD8JR66TeCRAFzZpZKZrkqPl+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)