UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXGnIP6+aZEw0C9w2Kj8ek9ZDf3BqE4gmn+epADjlXU='
WHERE
key_id = 'd9aadf962a28adcb7bb149163632b4e2b2a10d3e262eeff81b0f74c49d91a68b'
AND (
token = 'PXGnIP6+aZEw0C9w2Kj8ek9ZDf3BqE4gmn+epADjlXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)