UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GHg25GychvsTxwfX1xafT+V3XP+ZyYZMfU1GS5WD4To='
WHERE
key_id = '147f3b8545b19be0c8e688585f4da0843e2ed974b512d324a488d8c103b55b8b'
AND (
token = 'GHg25GychvsTxwfX1xafT+V3XP+ZyYZMfU1GS5WD4To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)