UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTy5gx4lOPiPdXNrgTBYE9Xwbhs6AIm8V8Ksy6wJgRM='
WHERE
key_id = '867bc0410864827915f9b5daf074f4880f9d6a513d4333cb6d0b46077358a79e'
AND (
token = 'NTy5gx4lOPiPdXNrgTBYE9Xwbhs6AIm8V8Ksy6wJgRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)