SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f9649a5656699016af1ef6a4b7753e8c6d789940ca74885f3cafdda0ec6d8297' 
  AND token = '5BcNCb6a7E+OfgAU+H6hqAU2QCqlJQoxO8aWpc7Z0nM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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