SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'f6cd2ace02af2cb55e61f1dab75ae1d360fd56f5d82f99483f1388aa8bc975e1' 
  AND token = 's1RD6KvQOj13Z49dv56ISDSU9h6h2YwDhj5r5q08e3o=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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