SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '01fdc5e45aca4029c4f629a0fbfd578d181dfda437b7c8817c94a1138cf2335f' 
  AND token = 'agTE5c2Ao5WuGKu57TOeLqDp9QVg6bUvnHdHl6zWhHQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

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