UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYeTB9eduV1hQRvoRvV4R7Qgj6IGxmicDkPQGD4ywHw='
WHERE
key_id = 'c382bce35c77834a27d4b7813a166dc3e414223892c1d30acf37aa445687d180'
AND (
token = 'pYeTB9eduV1hQRvoRvV4R7Qgj6IGxmicDkPQGD4ywHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)