SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '31abf7e16de85b3d6d1b38b7eb954ff28129673540e6dde31836a38fd2b33ca4' 
  AND token = 'AgMOfsrLMWSSQN0/u9Y4YMYx/YAnQyzh2VWMsFgf+SE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}