UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '08y7Y3GQLSd1BNGRmiXTzwRR6+6gBfd6mWf3StKqJ8Q=' 
WHERE 
  key_id = '814b2ee30f31ace5b7c0ee15fc8edbf3dfb7b98739e0834e4f1c4a13873a6e2b' 
  AND (
    token = '08y7Y3GQLSd1BNGRmiXTzwRR6+6gBfd6mWf3StKqJ8Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019