UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zi0pWKEutTrYpmaWr+VDQ7Bos/7Xa2INDw8fEq4VSGs='
WHERE
key_id = '2fcc81afb02e722f1dc3afb8d8191b0cc70082ac32c086a13b38cef3035ca4b6'
AND (
token = 'zi0pWKEutTrYpmaWr+VDQ7Bos/7Xa2INDw8fEq4VSGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)