UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nk7CnQrJobF1IAgUY5dpTmKtzagk9ASUV+WZarDTSVo='
WHERE
key_id = 'b46e8ca4a763e86a9873eb8f8780e6375e89d9fa73dcca6d34b74a183412958c'
AND (
token = 'Nk7CnQrJobF1IAgUY5dpTmKtzagk9ASUV+WZarDTSVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)