SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9822f147bbd3e277979ffd1a3be9174f8587ef04a36de5dbe98d764fb952ec7b' 
  AND token = 'hP6DA0FjrUli8Id89SsK42RC/3PWxPvNQavua8S5n20=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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