UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oAey/tvIdeguTOQs2WOyDQxQKqZAenXGhB1WgtWBCLw=' 
WHERE 
  key_id = 'b2107a088ee2609b3a96b817a46ed0393962dd1fcdbb9108beb685cf85091f96' 
  AND (
    token = 'oAey/tvIdeguTOQs2WOyDQxQKqZAenXGhB1WgtWBCLw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035