UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXjNH2VYI70xkf5EZQ0fXuTiNFd3vjNiQ2ESUFdOx40='
WHERE
key_id = '471aeeb70cb845124b3f688361cdc32f1ccc54c366e7187a7aa3e76b57aea89d'
AND (
token = 'BXjNH2VYI70xkf5EZQ0fXuTiNFd3vjNiQ2ESUFdOx40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)