UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC2Z1XyN2h5uexntHskjIuIk2AhyDyAx+RFba+PpPNA='
WHERE
key_id = 'c38fb0851b33511008e398e7b5bf52d0c96ae132e5d4247caf3d043752c1986a'
AND (
token = 'ZC2Z1XyN2h5uexntHskjIuIk2AhyDyAx+RFba+PpPNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)