SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4a9c3d210f66a4ae955a58fd0030c653c3f04440c0c90b239575957a1a1b2057' 
  AND token = 'spL9CSpBOPE1a00oBJ5gcRNyPLuR0iQ1o8/lFCHqWPo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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