UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6sECHIUF+DBbAjhRKU/NEWWIeuwlXQ/LKHNk2pMBuE='
WHERE
key_id = 'fb60cab816139f561df37e76fa044be8ef9c3fbd29d6ddc5d7c5550b739afee9'
AND (
token = 'H6sECHIUF+DBbAjhRKU/NEWWIeuwlXQ/LKHNk2pMBuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)