SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0bfeda060abc1a744fa5060246308079882cf2b3373b33f124e018bb66b6d635' 
  AND token = 'TBzXoQo9J7Vzns5Ogt/lBvdeuqTJ3FKTrpv/iAS2XZk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00047

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}