UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oH80LaDIkV1J6PUHvRK+Y86i2zVeAx4W3vSG9Wy0gQk=' 
WHERE 
  key_id = '41d3ec51144ee0b1250bfe8e7616ec9afd22bc41ba56b7927bb11e1ec5deafa8' 
  AND (
    token = 'oH80LaDIkV1J6PUHvRK+Y86i2zVeAx4W3vSG9Wy0gQk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023