UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYwOkkqLv3u4Ypi5imyv/Vjax0qTbBzOghuWEQqM4y4='
WHERE
key_id = '4f4e87aa2da9cda529884c39861c23ab29cd4627cb3e7aed2c25f9bb60f6d9e2'
AND (
token = 'nYwOkkqLv3u4Ypi5imyv/Vjax0qTbBzOghuWEQqM4y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)