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