UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8VQn9/pY/4lGEvXLuBDGusDANdj6JLtO7N/CP3i80S8=' 
WHERE 
  key_id = '7bc0596ca0fe3e8691013b905b7968910ce5c31602ed57491028330f63d34572' 
  AND (
    token = '8VQn9/pY/4lGEvXLuBDGusDANdj6JLtO7N/CP3i80S8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018