SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9e50921a3dfa32ee2e6e35d463591f46ee9288b0806ca10c0d34f2a5b7ea815d' 
  AND token = 'rn7CObIfn7uQNooqJT/PJ10KHQ7WjA1sjk/rmI38KSs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00044

JSON explain

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